1100 |
Is it is possible to exclude the non-working days when displaying the histogram using the exBarEffort for exHistOverAllocation type
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Tasks" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComLevelCount of hoChart to 2 Set ComPaneWidth of hoChart False to 40 Set ComFirstVisibleDate of hoChart to "6/20/2005" Set ComHistogramVisible of hoChart to True Set ComHistogramHeight of hoChart to 64 Set ComHistogramView of hoChart to OLEexHistogramAllItems Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternBDiagonal Set ComShape of hoBar to OLEexShapeThinUp Set ComColor of hoBar to (RGB(0,0,128)) Send Destroy to hoBar Send Destroy to hoBars Variant voBars1 Get ComBars of hoChart to voBars1 Handle hoBars1 Get Create (RefClass(cComBars)) to hoBars1 Set pvComObject of hoBars1 to voBars1 Variant voBar1 Get ComAdd of hoBars1 "Task:Split" to voBar1 Handle hoBar1 Get Create (RefClass(cComBar)) to hoBar1 Set pvComObject of hoBar1 to voBar1 Set ComColor of hoBar1 to (RGB(0,0,128)) Set ComShortcut of hoBar1 to "WorkingTask" Set ComPattern of hoBar1 to OLEexPatternBDiagonal Set ComHistogramPattern of hoBar1 to OLEexPatternBDiagonal Set ComHistogramType of hoBar1 to OLEexHistOverAllocation Send Destroy to hoBar1 Send Destroy to hoBars1 Variant voBars2 Get ComBars of hoChart to voBars2 Handle hoBars2 Get Create (RefClass(cComBars)) to hoBars2 Set pvComObject of hoBars2 to voBars2 Variant voBar2 Get ComItem of hoBars2 "Task" to voBar2 Handle hoBar2 Get Create (RefClass(cComBar)) to hoBar2 Set pvComObject of hoBar2 to voBar2 Set ComColor of hoBar2 to (RGB(0,0,255)) Set ComPattern of hoBar2 to OLEexPatternFDiagonal Set ComHistogramType of hoBar2 to OLEexHistOverAllocation Set ComHistogramPattern of hoBar2 to OLEexPatternFDiagonal Send Destroy to hoBar2 Send Destroy to hoBars2 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "True" to h Send ComAddBar of hoItems h "WorkingTask" "6/23/2005" "6/29/2005" Nothing Nothing Set ComItemBar of hoItems h "" OLEexBarEffort to 4 Set ComItemBar of hoItems h "" OLEexBarKeepWorkingCount to True Get ComAddItem of hoItems "False" to h Send ComAddBar of hoItems h "Task" "6/23/2005" "6/29/2005" Nothing Nothing Set ComItemBar of hoItems h "" OLEexBarEffort to 4 Set ComItemBar of hoItems h "" OLEexBarKeepWorkingCount to False Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1099 |
I display numbers in my chart, but the AddBar requires a date how can I add a bar
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Tasks" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComNonworkingDays of hoChart to 0 Set ComFirstVisibleDate of hoChart to 0 Set ComToolTip of hoChart to "" Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%i%>" Set ComToolTip of hoLevel to "" Send Destroy to hoLevel Set ComUnitWidth of hoChart to 24 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 1")) "Task" 2 4 Nothing Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" 6 10 Nothing Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1098 |
I display numbers in the chart's header but do not want to get displayed negative numbers. How can i do that
// Occurs when the first visible date is changed. Procedure OnComDateChange Forward Send OnComDateChange Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to 0 Send Destroy to hoChart Set ComScrollPartEnable OLEexHChartScroll OLEexLeftBPart to False End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Set ComPaneWidth of hoChart1 False to 0 Set ComNonworkingDays of hoChart1 to 0 Set ComFirstVisibleDate of hoChart1 to 0 Set ComToolTip of hoChart1 to "" Variant voLevel Get ComLevel of hoChart1 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%i%>" Set ComToolTip of hoLevel to "<%i%>" Send Destroy to hoLevel Set ComUnitWidth of hoChart1 to 24 Send Destroy to hoChart1 Send ComEndUpdate End_Procedure |
1097 |
How can I display numbers in the chart's header instead dates
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComNonworkingDays of hoChart to 0 Set ComFirstVisibleDate of hoChart to 0 Set ComToolTip of hoChart to "" Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%i%>" Set ComToolTip of hoLevel to "" Send Destroy to hoLevel Set ComUnitWidth of hoChart to 24 Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1096 |
How can I create a bar that's not sizable, or can not be resized by default similar with milestone
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "12/24/2000" Set ComLevelCount of hoChart to 2 Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Custom" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShape of hoBar to OLEexShapeEmpty Set ComStartShape of hoBar to OLEexShapeIconUp1 Set ComEndShape of hoBar to OLEexShapeIconEmpty Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Send ComAddBar of hoItems (ComAddItem(hoItems,"")) "Custom" "1/2/2001" "1/2/2001" "K1" "This TYPE of bar can not be resized." Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1095 |
Is it possible to hide the non-working parts for items using the ItemNonworkingUnits, even if set the ShowNonworkingUnits, ShowNonworkingDates on False
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "12/27/2000" Set ComPaneWidth of hoChart False to 64 Set ComLevelCount of hoChart to 2 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Set ComNonworkingDaysPattern of hoChart to OLEexPatternEmpty Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Set ComItemNonworkingUnits of hoItems h2 false to "weekday(value) = 1" Send ComAddBar of hoItems h2 "Task" "1/4/2001" "1/6/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/8/2001" "1/10/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1094 |
Is it possible to show the non-working parts for certain items, even if I hide the default non-working part
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "12/27/2000" Set ComPaneWidth of hoChart False to 64 Set ComLevelCount of hoChart to 2 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Set ComItemNonworkingUnits of hoItems h2 false to "weekday(value) = 1" Send ComAddBar of hoItems h2 "Task" "1/4/2001" "1/6/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/8/2001" "1/10/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1093 |
How can I hide the non-working part of the chart
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2008" Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1092 |
Is it possible to let users selects cells as in Excel
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComFullRowSelect to OLEexRectSel Set ComSingleSel to False Set ComReadOnly to OLEexReadOnly Set ComMarkSearchColumn to False Set ComShowFocusRect to False Set ComLinesAtRoot to OLEexLinesAtRoot Set ComSelForeColor to (RGB(0,0,0)) Set ComSelBackColor to (RGB(200,225,242)) Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "A" to Nothing Variant voColumn Get ComAdd of hoColumns "B" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComAllowSizing of hoColumn to False Set ComWidth of hoColumn to 24 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "C" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComAllowSizing of hoColumn1 to False Set ComWidth of hoColumn1 to 24 Set ComDef of hoColumn1 OLEexCellHasCheckBox to 1 Set ComPartialCheck of hoColumn1 to True Send Destroy to hoColumn1 Variant voColumn2 Get ComAdd of hoColumns "D" to voColumn2 Handle hoColumn2 Get Create (RefClass(cComColumn)) to hoColumn2 Set pvComObject of hoColumn2 to voColumn2 Set ComAllowSizing of hoColumn2 to False Set ComWidth of hoColumn2 to 24 Set ComDef of hoColumn2 OLEexCellHasRadioButton to 1 Send Destroy to hoColumn2 Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComInsertItem of hoItems "Group 1" to h Variant h1 Get ComInsertItem of hoItems h 16 to h1 Set ComCellValue of hoItems h1 1 to 17 Get ComInsertItem of hoItems h 2 to h1 Set ComCellValue of hoItems h1 1 to 11 Get ComInsertItem of hoItems h 2 to h1 Set ComItemBackColor of hoItems h1 to (RGB(240,240,240)) Set ComCellValue of hoItems h1 1 to 9 Set ComExpandItem of hoItems h to True Get ComInsertItem of hoItems "Group 2" to h Set ComCellValueFormat of hoItems h 2 to OLEexHTML Get ComInsertItem of hoItems h 16 to h1 Set ComCellValue of hoItems h1 1 to 9 Get ComInsertItem of hoItems h 12 to h1 Set ComCellValue of hoItems h1 1 to 11 Get ComInsertItem of hoItems h 2 to h1 Set ComCellValue of hoItems h1 1 to 2 Set ComExpandItem of hoItems h to True Set ComSelectItem of hoItems h to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1091 |
How can I hide a date from the chart view
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2008" Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Set ComAllowInsideZoom of hoChart to True Set ComAllowResizeInsideZoom of hoChart to False Set ComInsideZoomOnDblClick of hoChart to False Variant voInsideZooms Get ComInsideZooms of hoChart to voInsideZooms Handle hoInsideZooms Get Create (RefClass(cComInsideZooms)) to hoInsideZooms Set pvComObject of hoInsideZooms to voInsideZooms Set ComSplitBaseLevel of hoInsideZooms to False Set ComDefaultWidth of hoInsideZooms to 0 Get ComAdd of hoInsideZooms "1/4/2008" to Nothing Get ComAdd of hoInsideZooms "1/5/2008" to Nothing Get ComAdd of hoInsideZooms "1/6/2008" to Nothing Send Destroy to hoInsideZooms Set ComSelectLevel of hoChart to 1 Set ComSelectDate of hoChart "1/5/2008" to True Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1090 |
Can the SchedulePDM displays and edit the working units for my bars
// Occurs when a bar is moving or resizing. Procedure OnComBarResizing HITEM llItem Variant llKey Forward Send OnComBarResizing llItem llKey Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComSchedulePDM of hoItems llItem llKey to Nothing Send Destroy to hoItems End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComAllowCellValueToItemBar of hoItems1 to True Send Destroy to hoItems1 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComAdd of hoColumns1 "Working" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 258 Variant voEditor Get ComEditor of hoColumn to voEditor Handle hoEditor Get Create (RefClass(cComEditor)) to hoEditor Set pvComObject of hoEditor to voEditor Set ComEditType of hoEditor to OLESpinType Send Destroy to hoEditor Send Destroy to hoColumn Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 96 Set ComAllowLinkBars of hoChart to False Set ComAllowCreateBar of hoChart to OLEexNoCreateBar Send Destroy to hoChart Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Variant h1 Get ComAddItem of hoItems2 "Task 1" to h1 Send ComAddBar of hoItems2 h1 "Task" "1/2/2001" "1/4/2001" "" Nothing Variant h2 Get ComAddItem of hoItems2 "Task 2" to h2 Send ComAddBar of hoItems2 h2 "Task" "1/2/2001" "1/4/2001" "" Nothing Send ComAddLink of hoItems2 "L1" h1 "" h2 "" Variant h3 Get ComAddItem of hoItems2 "Task 3" to h3 Send ComAddBar of hoItems2 h3 "Task" "1/2/2001" "1/6/2001" "" Nothing Send ComAddLink of hoItems2 "L2" h2 "" h3 "" Set ComLink of hoItems2 "L2" OLEexLinkText to "FF" Set ComLink of hoItems2 "L2" OLEexLinkStartPos to 2 Set ComLink of hoItems2 "L2" OLEexLinkEndPos to 2 Variant h4 Get ComAddItem of hoItems2 "Task 4" to h4 Send ComAddBar of hoItems2 h4 "Task" "1/2/2001" "1/4/2001" "" Nothing Send ComAddLink of hoItems2 "L3" h4 "" h3 "" Set ComItemBar of hoItems2 0 "<*>" OLEexBarKeepWorkingCount to True Get ComSchedulePDM of hoItems2 (ComFirstVisibleItem(hoItems2)) "" to Nothing Send Destroy to hoItems2 Send ComEndUpdate End_Procedure |
1089 |
Can the SchedulePDM displays the working units for my bars
// Occurs when a bar is moving or resizing. Procedure OnComBarResizing HITEM llItem Variant llKey Forward Send OnComBarResizing llItem llKey Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComSchedulePDM of hoItems llItem llKey to Nothing Send Destroy to hoItems End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComAllowCellValueToItemBar of hoItems1 to True Send Destroy to hoItems1 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComAdd of hoColumns1 "Working" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 258 Send Destroy to hoColumn Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 96 Set ComAllowLinkBars of hoChart to False Set ComAllowCreateBar of hoChart to OLEexNoCreateBar Send Destroy to hoChart Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Variant h1 Get ComAddItem of hoItems2 "Task 1" to h1 Send ComAddBar of hoItems2 h1 "Task" "1/2/2001" "1/4/2001" "" Nothing Variant h2 Get ComAddItem of hoItems2 "Task 2" to h2 Send ComAddBar of hoItems2 h2 "Task" "1/2/2001" "1/4/2001" "" Nothing Send ComAddLink of hoItems2 "L1" h1 "" h2 "" Variant h3 Get ComAddItem of hoItems2 "Task 3" to h3 Send ComAddBar of hoItems2 h3 "Task" "1/2/2001" "1/6/2001" "" Nothing Send ComAddLink of hoItems2 "L2" h2 "" h3 "" Set ComLink of hoItems2 "L2" OLEexLinkText to "FF" Set ComLink of hoItems2 "L2" OLEexLinkStartPos to 2 Set ComLink of hoItems2 "L2" OLEexLinkEndPos to 2 Variant h4 Get ComAddItem of hoItems2 "Task 4" to h4 Send ComAddBar of hoItems2 h4 "Task" "1/2/2001" "1/4/2001" "" Nothing Send ComAddLink of hoItems2 "L3" h4 "" h3 "" Set ComItemBar of hoItems2 0 "<*>" OLEexBarKeepWorkingCount to True Get ComSchedulePDM of hoItems2 (ComFirstVisibleItem(hoItems2)) "" to Nothing Send Destroy to hoItems2 Send ComEndUpdate End_Procedure |
1088 |
Can the SchedulePDM keeps the working units for my bars
// Occurs when a bar is moving or resizing. Procedure OnComBarResizing HITEM llItem Variant llKey Forward Send OnComBarResizing llItem llKey Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComSchedulePDM of hoItems llItem llKey to Nothing Send Destroy to hoItems End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 48 Set ComAllowLinkBars of hoChart to False Set ComAllowCreateBar of hoChart to OLEexNoCreateBar Send Destroy to hoChart Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h1 Get ComAddItem of hoItems1 "Task 1" to h1 Send ComAddBar of hoItems1 h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems1 "Task 2" to h2 Send ComAddBar of hoItems1 h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems1 "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems1 "Task 3" to h3 Send ComAddBar of hoItems1 h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems1 "L2" h2 "K2" h3 "K3" Set ComLink of hoItems1 "L2" OLEexLinkText to "FF" Set ComLink of hoItems1 "L2" OLEexLinkStartPos to 2 Set ComLink of hoItems1 "L2" OLEexLinkEndPos to 2 Variant h4 Get ComAddItem of hoItems1 "Task 4" to h4 Send ComAddBar of hoItems1 h4 "Task" "1/2/2001" "1/4/2001" "K4" Nothing Send ComAddLink of hoItems1 "L3" h4 "K4" h3 "K3" Set ComItemBar of hoItems1 0 "<*>" OLEexBarKeepWorkingCount to True Get ComSchedulePDM of hoItems1 0 "K1" to Nothing Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1087 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
// Occurs when a bar is moving or resizing. Procedure OnComBarResizing HITEM llItem Variant llKey Forward Send OnComBarResizing llItem llKey Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComSchedulePDM of hoItems llItem llKey to Nothing Send Destroy to hoItems End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 48 Set ComAllowLinkBars of hoChart to False Set ComAllowCreateBar of hoChart to OLEexNoCreateBar Send Destroy to hoChart Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h1 Get ComAddItem of hoItems1 "Task 1" to h1 Send ComAddBar of hoItems1 h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems1 "Task 2" to h2 Send ComAddBar of hoItems1 h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems1 "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems1 "Task 3" to h3 Send ComAddBar of hoItems1 h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems1 "L2" h2 "K2" h3 "K3" Set ComLink of hoItems1 "L2" OLEexLinkText to "FF" Set ComLink of hoItems1 "L2" OLEexLinkStartPos to 2 Set ComLink of hoItems1 "L2" OLEexLinkEndPos to 2 Variant h4 Get ComAddItem of hoItems1 "Task 4" to h4 Send ComAddBar of hoItems1 h4 "Task" "1/2/2001" "1/4/2001" "K4" Nothing Send ComAddLink of hoItems1 "L3" h4 "K4" h3 "K3" Get ComSchedulePDM of hoItems1 0 "K1" to Nothing Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1086 |
How can I arrange automatically the bars based on their links as soon as user moves the bars
// Occurs when a bar is moved or resized. Procedure OnComBarResize HITEM llItem Variant llKey Forward Send OnComBarResize llItem llKey Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComSchedulePDM of hoItems llItem llKey to Nothing Send Destroy to hoItems End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Set ComAllowLinkBars of hoChart to False Set ComAllowCreateBar of hoChart to OLEexNoCreateBar Send Destroy to hoChart Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h1 Get ComAddItem of hoItems1 "Task 1" to h1 Send ComAddBar of hoItems1 h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems1 "Task 2" to h2 Send ComAddBar of hoItems1 h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems1 "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems1 "Task 3" to h3 Send ComAddBar of hoItems1 h3 "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddLink of hoItems1 "L2" h2 "K2" h3 "K3" Get ComSchedulePDM of hoItems1 0 "K1" to Nothing Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1085 |
I have some buttons added on the control's scroll bar, how can I can know when the button is being clicked
// Occurs when the user clicks a button in the scrollbar. Procedure OnComScrollButtonClick OLEScrollBarEnum llScrollBar OLEScrollPartEnum llScrollPart Forward Send OnComScrollButtonClick llScrollBar llScrollPart Showln llScrollBar llScrollPart End_Procedure Procedure OnCreate Forward Send OnCreate Set ComScrollPartVisible OLEexHScroll OLEexLeftB1Part to True Set ComScrollPartVisible OLEexHScroll OLEexLeftB2Part to True Set ComScrollPartVisible OLEexHScroll OLEexRightB6Part to True Set ComScrollPartVisible OLEexHScroll OLEexRightB5Part to True Set ComScrollBars to OLEexDisableNoHorizontal End_Procedure |
1084 |
How do I get notified once the user clicks a hyperlink created using the anchor HTML tag
// Occurs when an anchor element is clicked. Procedure OnComAnchorClick String llAnchorID String llOptions Forward Send OnComAnchorClick llAnchorID llOptions Showln llAnchorID llOptions End_Procedure Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Default" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellValueFormat to 1 Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "This is a link: <aex.com;1>www.exontrol.com</a>" to Nothing Get ComAddItem of hoItems "This is a link: <aex.net;2>www.exontrol.net</a>" to Nothing Send Destroy to hoItems End_Procedure |
1083 |
Is it possible to start editing a cell when double click it
// Occurs when the user dblclk the left mouse button over an object. Procedure OnComDblClick Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComDblClick llShift llX llY Send ComEdit Nothing End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComAutoEdit to False Set ComMarkSearchColumn to False Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Edit1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Variant voEditor Get ComEditor of hoColumn to voEditor Handle hoEditor Get Create (RefClass(cComEditor)) to hoEditor Set pvComObject of hoEditor to voEditor Set ComEditType of hoEditor to OLEEditType Send Destroy to hoEditor Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Edit2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Variant voEditor1 Get ComEditor of hoColumn1 to voEditor1 Handle hoEditor1 Get Create (RefClass(cComEditor)) to hoEditor1 Set pvComObject of hoEditor1 to voEditor1 Set ComEditType of hoEditor1 to OLEEditType Send Destroy to hoEditor1 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,1)) 1 to 2 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,3)) 1 to 4 Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1082 |
Is it possible to disable standard single-click behavior for this column, so I manually could call Edit() when needed
// Occurs when the user dblclk the left mouse button over an object. Procedure OnComDblClick Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComDblClick llShift llX llY Send ComEdit Nothing End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComAutoEdit to False Set ComMarkSearchColumn to False Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Edit1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Variant voEditor Get ComEditor of hoColumn to voEditor Handle hoEditor Get Create (RefClass(cComEditor)) to hoEditor Set pvComObject of hoEditor to voEditor Set ComEditType of hoEditor to OLEEditType Send Destroy to hoEditor Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Edit2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Variant voEditor1 Get ComEditor of hoColumn1 to voEditor1 Handle hoEditor1 Get Create (RefClass(cComEditor)) to hoEditor1 Set pvComObject of hoEditor1 to voEditor1 Set ComEditType of hoEditor1 to OLEEditType Send Destroy to hoEditor1 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellValue of hoItems (ComAddItem(hoItems,1)) 1 to 2 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,3)) 1 to 4 Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1081 |
How can I get or restore the old or previously value for the cell being changed
// Occurs when the user changes the cell's content. Procedure OnComChange HITEM llItem Integer llColIndex Variant llNewValue Forward Send OnComChange llItem llColIndex llNewValue Variant v Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComCellValue of hoItems llItem llColIndex to v Send Destroy to hoItems Showln "Old-Value:" v Showln "New-Value:" llNewValue End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComMarkSearchColumn to False Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Edit1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Variant voEditor Get ComEditor of hoColumn to voEditor Handle hoEditor Get Create (RefClass(cComEditor)) to hoEditor Set pvComObject of hoEditor to voEditor Set ComEditType of hoEditor to OLEEditType Send Destroy to hoEditor Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Edit2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Variant voEditor1 Get ComEditor of hoColumn1 to voEditor1 Handle hoEditor1 Get Create (RefClass(cComEditor)) to hoEditor1 Set pvComObject of hoEditor1 to voEditor1 Set ComEditType of hoEditor1 to OLEEditType Send Destroy to hoEditor1 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellValue of hoItems1 (ComAddItem(hoItems1,1)) 1 to 2 Send Destroy to hoItems1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Set ComCellValue of hoItems2 (ComAddItem(hoItems2,3)) 1 to 4 Send Destroy to hoItems2 Send ComEndUpdate End_Procedure |
1080 |
How can I display the number of items being found after filtering
// Occurs when the filter was changed. Procedure OnComFilterChange Forward Send OnComFilterChange Variant v Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComVisibleCount of hoItems to v Send Destroy to hoItems Set ComFilterBarCaption to v End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptContainsAll Set ComFilterBarPromptPattern to "london" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h0 Get ComAddItem of hoItems1 "Nancy Davolio" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "Seattle" Get ComAddItem of hoItems1 "Andrew Fuller" to h0 Set ComCellValue of hoItems1 h0 1 to "Vice President, Sales" Set ComCellValue of hoItems1 h0 2 to "Tacoma" Set ComSelectItem of hoItems1 h0 to True Get ComAddItem of hoItems1 "Janet Leverling" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "Kirkland" Get ComAddItem of hoItems1 "Margaret Peacock" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "Redmond" Get ComAddItem of hoItems1 "Steven Buchanan" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Manager" Set ComCellValue of hoItems1 h0 2 to "London" Get ComAddItem of hoItems1 "Michael Suyama" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "London" Get ComAddItem of hoItems1 "Robert King" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "London" Get ComAddItem of hoItems1 "Laura Callahan" to h0 Set ComCellValue of hoItems1 h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems1 h0 2 to "Seattle" Get ComAddItem of hoItems1 "Anne Dodsworth" to h0 Set ComCellValue of hoItems1 h0 1 to "Sales Representative" Set ComCellValue of hoItems1 h0 2 to "London" Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1079 |
How can I highligth the item from the cursor as it moves
// Occurs when the user moves the mouse. Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComMouseMove llButton llShift llX llY Send ComBeginUpdate Variant h Get ComItemFromPoint -1 -1 c hit to h Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant vItem Get ComBackground (|CI$200 + OLEexHSRight + OLEexListOLEDropPosition) to vItem Send ComClearItemBackColor of hoItems vItem Set ComItemBackColor of hoItems h to (RGB(240,250,240)) Send Destroy to hoItems Set ComBackground (|CI$200 + OLEexHSRight + OLEexListOLEDropPosition) to h Send ComEndUpdate End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComLinesAtRoot to OLEexLinesAtRoot Set ComDrawGridLines to OLEexHLines Set ComSelBackColor to (RGB(240,250,240)) Set ComSelForeColor to (RGB(0,0,0)) Set ComShowFocusRect to False Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComSelBackColor of hoChart to (RGB(240,250,240)) Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Items" to Nothing Send Destroy to hoColumns Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "R1" to h Get ComInsertItem of hoItems1 h "Cell 1.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 1.2" to Nothing Set ComExpandItem of hoItems1 h to True Get ComAddItem of hoItems1 "R2" to h Get ComInsertItem of hoItems1 h "Cell 2.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 2.2" to Nothing Set ComExpandItem of hoItems1 h to True Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1078 |
How can I get the item from the cursor
// Occurs when the user moves the mouse. Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComMouseMove llButton llShift llX llY Variant h Get ComItemFromPoint -1 -1 c hit to h Variant v Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComItemToIndex of hoItems h to v Send Destroy to hoItems Showln "Handle" h "Index" v End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComLinesAtRoot to OLEexLinesAtRoot Set ComDrawGridLines to OLEexHLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Items" to Nothing Send Destroy to hoColumns Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "R1" to h Get ComInsertItem of hoItems1 h "Cell 1.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 1.2" to Nothing Set ComExpandItem of hoItems1 h to True Get ComAddItem of hoItems1 "R2" to h Get ComInsertItem of hoItems1 h "Cell 2.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 2.2" to Nothing Set ComExpandItem of hoItems1 h to True Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1077 |
How can I get the column from the cursor, not only in the header
// Occurs when the user moves the mouse. Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComMouseMove llButton llShift llX llY Showln (ComColumnFromPoint(Self,-1,0)) End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "P1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "P2" to Nothing Send Destroy to hoColumns1 Set ComDrawGridLines to OLEexAllLines Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "R1" to h Set ComCellValue of hoItems h 1 to "R2" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 1.1")) 1 to "Cell 1.2" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 2.1")) 1 to "Cell 2.2" Set ComExpandItem of hoItems h to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1076 |
How can I get the column from the cursor
// Occurs when the user moves the mouse. Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComMouseMove llButton llShift llX llY Showln (ComColumnFromPoint(Self,-1,-1)) End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComLinesAtRoot to OLEexLinesAtRoot Set ComDrawGridLines to OLEexAllLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "P1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "P2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "R1" to h Set ComCellValue of hoItems h 1 to "R2" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 1.1")) 1 to "Cell 1.2" Set ComCellValue of hoItems (ComInsertItem(hoItems,h,"Cell 2.1")) 1 to "Cell 2.2" Set ComExpandItem of hoItems h to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1075 |
How can I get the cell's caption from the cursor
// Occurs when the user moves the mouse. Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY Forward Send OnComMouseMove llButton llShift llX llY Variant h Get ComItemFromPoint -1 -1 c hit to h Variant v Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComCellCaption of hoItems h c to v Send Destroy to hoItems Showln v End_Procedure Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Items" to Nothing Send Destroy to hoColumns Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "R1" to h Get ComInsertItem of hoItems1 h "Cell 1.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 1.2" to Nothing Set ComExpandItem of hoItems1 h to True Get ComAddItem of hoItems1 "R2" to h Get ComInsertItem of hoItems1 h "Cell 2.1" to Nothing Get ComInsertItem of hoItems1 h "Cell 2.2" to Nothing Set ComExpandItem of hoItems1 h to True Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1074 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
|
1073 |
How can I show the bars over the grid lines, i.e. so you cannot see the grid lines 'through' the bar
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComDrawGridLines to OLEexAllLines Set ComGridLineColor to (RGB(220,220,220)) Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesBehind Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Set ComGridLineColor of hoLevel to (RGB(220,220,220)) Send Destroy to hoLevel Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternSolid Set ComHeight of hoBar to 14 Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Item 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "A" Nothing Send ComAddBar of hoItems h "Task" "1/8/2001" "1/15/2001" "B" Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1072 |
Is it possible to change the style for the vertical grid lines, in the chart area only
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComDrawGridLines to OLEexAllLines Set ComGridLineStyle to OLEexGridLinesDash Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesDash Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 0 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComGridLineColor of hoLevel1 to (RGB(255,0,0)) Set ComGridLineStyle of hoLevel1 to OLEexGridLinesVSolid Send Destroy to hoLevel1 Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternSolid Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Item 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "A" Nothing Send ComAddBar of hoItems h "Task" "1/8/2001" "1/15/2001" "B" Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1071 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComDrawGridLines to OLEexAllLines Set ComGridLineStyle to OLEexGridLinesSolid Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesSolid Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Send Destroy to hoLevel Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternSolid Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Item 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "A" Nothing Send ComAddBar of hoItems h "Task" "1/8/2001" "1/15/2001" "B" Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1070 |
How can I show the grid lines for the chart and list area
Procedure OnCreate Forward Send OnCreate Set ComDrawGridLines to OLEexAllLines Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Send Destroy to hoLevel Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternSolid Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Item 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "A" Nothing Send ComAddBar of hoItems h "Task" "1/8/2001" "1/15/2001" "B" Nothing Send Destroy to hoItems End_Procedure |
1069 |
In the level of the chart we are showing the week number of the year (1-53) (Week: ww). However the weeknumber isn't correct. In western Europe the week of 04/01/2010 till 10/01/2010 is weeknumber 1, however the g2antt says it's week 2
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "12/28/2009" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "Week: <%ww%>/<%yyyy%>" Send Destroy to hoLevel Set ComFirstWeekDay of hoChart to OLEexMonday Send Destroy to hoChart End_Procedure |
1068 |
How can I determine the current visible date range of the gantt chart area
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 1")) "Task" "1/2/2001" "1/6/2001" Nothing Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/3/2001" "1/7/2001" Nothing Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 3")) "Task" "1/4/2001" "1/8/2001" Nothing Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/6/2001" "1/10/2001" Nothing Nothing Send Destroy to hoItems Variant v Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Get ComStartPrintDate of hoChart1 to v Send Destroy to hoChart1 Variant v1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Get ComEndPrintDate of hoChart2 to v1 Send Destroy to hoChart2 Showln v v1 End_Procedure |
1067 |
How can I change the progress bar using a spin editor using values from 0 to 100
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComAllowCellValueToItemBar of hoItems to True Send Destroy to hoItems Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Variant voColumn Get ComAdd of hoColumns "Percent" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Variant voEditor Get ComEditor of hoColumn to voEditor Handle hoEditor Get Create (RefClass(cComEditor)) to hoEditor Set pvComObject of hoEditor to voEditor Set ComEditType of hoEditor to OLESpinType Send Destroy to hoEditor Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 518 Send Destroy to hoColumn Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Get ComAdd of hoBars "Task%Progress" to Nothing Send Destroy to hoBars Send Destroy to hoChart Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h Get ComAddItem of hoItems1 "Task 1" to h Send ComAddBar of hoItems1 h "Task%Progress" "1/2/2001" "1/6/2001" Nothing Nothing Set ComCellValue of hoItems1 h 1 to 40 Get ComAddItem of hoItems1 "Task 2" to h Send ComAddBar of hoItems1 h "Task%Progress" "1/2/2001" "1/6/2001" Nothing Nothing Set ComCellValue of hoItems1 h 1 to 50 Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1066 |
Is it possible to display the histogram for selected bars only
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComLevelCount of hoChart to 2 Set ComPaneWidth of hoChart False to 64 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComHistogramVisible of hoChart to True Set ComHistogramView of hoChart to OLEexHistogramSelectedBars Set ComHistogramHeight of hoChart to 32 Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComHistogramPattern of hoBar to OLEexPatternBDiagonal Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/3/2001" "1/5/2001" 1 Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "1/4/2001" "1/7/2001" 2 Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "1/2/2001" "1/6/2001" 3 Nothing Set ComItemBar of hoItems 0 2 OLEexBarSelected to True Set ComItemBar of hoItems 0 3 OLEexBarSelected to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1065 |
How can I fix a bar, so it is not selectable, moveable or resizable, fixed in other words
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/8/2001" "K1" "Unselectable" Set ComItemBar of hoItems h1 "K1" OLEexBarSelectable to False Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1064 |
How can I fix a bar, so it is not moveable or resizable
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" "Fixed" Set ComItemBar of hoItems h1 "K1" OLEexBarCanResize to False Set ComItemBar of hoItems h1 "K1" OLEexBarCanMove to False Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1063 |
Is is possible to fix a bar during PDM scheduling
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "TaskF" "1/2/2001" "1/4/2001" "K1" Nothing Set ComItemBar of hoItems h1 "K1" OLEexBarCanResize to False Set ComItemBar of hoItems h1 "K1" OLEexBarCanMove to False Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "TaskF" "1/2/2001" "1/4/2001" "K3" Nothing Set ComItemBar of hoItems h3 "K3" OLEexBarCanResize to False Set ComItemBar of hoItems h3 "K3" OLEexBarCanMove to False Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1062 |
How can I specify that during scheduling the link, bars should be delayed, on working part
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/1/2001" "1/3/2001" "K1" Nothing Set ComItemBar of hoItems h1 "K1" OLEexBarKeepWorkingCount to True Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Set ComItemBar of hoItems h2 "K2" OLEexBarKeepWorkingCount to True Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Set ComItemBar of hoItems h3 "K3" OLEexBarKeepWorkingCount to True Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "link delays the bars<br>for <b>2</b> working days" Set ComLink of hoItems "L2" OLEexLinkPDMWorkingDelay to 2 Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1061 |
How can I specify that during scheduling the link, bars should be delayed
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComShowNonworkingDates of hoChart to False Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to " Finish-Start<br>delayed <b>4</b> days" Set ComLink of hoItems "L2" OLEexLinkPDMDelay to 4 Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1060 |
The SchedulePDM method put the bars on non-working part, how can I prevent that
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Set ComItemBar of hoItems h1 "K1" OLEexBarKeepWorkingCount to True Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Set ComItemBar of hoItems h2 "K2" OLEexBarKeepWorkingCount to True Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Set ComItemBar of hoItems h3 "K3" OLEexBarKeepWorkingCount to True Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "FS" Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1059 |
How can I add a SF (Start-Finish) link so activities get arranged using the SchedulePDM
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "SF" Set ComLink of hoItems "L2" OLEexLinkStartPos to 0 Set ComLink of hoItems "L2" OLEexLinkEndPos to 2 Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1058 |
How can I add a SS (Start-Start) link so activities get arranged using the SchedulePDM
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "SS" Set ComLink of hoItems "L2" OLEexLinkStartPos to 0 Set ComLink of hoItems "L2" OLEexLinkEndPos to 0 Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1057 |
How can I add a FF (Finish-Finish) link so activities get arranged using the SchedulePDM
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "12/28/2000" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "FF" Set ComLink of hoItems "L2" OLEexLinkStartPos to 2 Set ComLink of hoItems "L2" OLEexLinkEndPos to 2 Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1056 |
How can I add a FS (Finish-Start) link so activities get arranged using the SchedulePDM
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/5/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Set ComLink of hoItems "L1" OLEexLinkText to "FS" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/6/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Set ComLink of hoItems "L2" OLEexLinkText to "FS" Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1055 |
How can I schedule activities in the project plan
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h3 "K3" h2 "K2" Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1054 |
How do I arrange the bars based on the links
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h1 Get ComAddItem of hoItems "Task 1" to h1 Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing Variant h2 Get ComAddItem of hoItems "Task 2" to h2 Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddLink of hoItems "L1" h1 "K1" h2 "K2" Variant h3 Get ComAddItem of hoItems "Task 3" to h3 Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddLink of hoItems "L2" h2 "K2" h3 "K3" Get ComSchedulePDM of hoItems 0 "K1" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1053 |
Is is possible to use HTML tags to display in the filter caption
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComFilterBarPromptVisible to True Set ComFilterBarCaption to "This is a bit of text being displayed in the filter bar." Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "Item 1" to Nothing Get ComAddItem of hoItems "Item 2" to Nothing Get ComAddItem of hoItems "Item 3" to Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1052 |
How can I find the number of items after filtering
|
1051 |
How can I change the filter caption
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to (OLEexFilterPromptWords + OLEexFilterPromptContainsAll) Set ComFilterBarPromptPattern to "london robert" Set ComFilterBarCaption to "<r>Found: ... " Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1050 |
While using the filter prompt is it is possible to use wild characters
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptPattern Set ComFilterBarPromptPattern to "lon* seat*" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1049 |
How can I list all items that contains any of specified words, not necessary at the beggining
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to (OLEexFilterPromptStartWords + OLEexFilterPromptContainsAny) Set ComFilterBarPromptPattern to "london davolio" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1048 |
How can I list all items that contains any of specified words, not strings
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to (OLEexFilterPromptWords + OLEexFilterPromptContainsAny) Set ComFilterBarPromptPattern to "london nancy" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1047 |
How can I list all items that contains all specified words, not strings
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to (OLEexFilterPromptWords + OLEexFilterPromptContainsAll) Set ComFilterBarPromptPattern to "london robert" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1046 |
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to (OLEexFilterPromptCaseSensitive + OLEexFilterPromptContainsAny) Set ComFilterBarPromptPattern to "Anne" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1045 |
Is it possible to list only items that ends with any of specified strings
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptEndWith Set ComFilterBarPromptColumns to "0" Set ComFilterBarPromptPattern to "Fuller" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1044 |
Is it possible to list only items that ends with any of specified strings
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptEndWith Set ComFilterBarPromptColumns to "0" Set ComFilterBarPromptPattern to "Fuller" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1043 |
Is it possible to list only items that starts with any of specified strings
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptStartWith Set ComFilterBarPromptColumns to "0" Set ComFilterBarPromptPattern to "An M" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1042 |
Is it possible to list only items that starts with specified string
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptStartWith Set ComFilterBarPromptColumns to "0" Set ComFilterBarPromptPattern to "A" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1041 |
How can I specify that the list should include any of the seqeunces in the pattern
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptContainsAny Set ComFilterBarPromptPattern to "london seattle" Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1040 |
How can I specify that all sequences in the filter pattern must be included in the list
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptType to OLEexFilterPromptContainsAll Set ComFilterBarPromptPattern to "london manager" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1039 |
How do I change at runtime the filter prompt
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptPattern to "london manager" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1038 |
How do I specify to filter only a single column when using the filter prompt
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPromptColumns to "2,3" Set ComFilterBarPromptPattern to "london" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1037 |
How do I change the prompt or the caption being displayed in the filter bar
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Set ComFilterBarPrompt to "changed" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Send ComEndUpdate End_Procedure |
1036 |
How do I enable the filter prompt feature
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart True to 0 Send Destroy to hoChart Set ComColumnAutoResize to True Set ComContinueColumnScroll to False Set ComFocusColumnIndex to 1 Set ComMarkSearchColumn to False Set ComSearchColumnIndex to 1 Set ComFilterBarPromptVisible to True Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Name" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 96 Send Destroy to hoColumn Variant voColumn1 Get ComAdd of hoColumns "Title" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComWidth of hoColumn1 to 96 Send Destroy to hoColumn1 Get ComAdd of hoColumns "City" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h0 Get ComAddItem of hoItems "Nancy Davolio" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Andrew Fuller" to h0 Set ComCellValue of hoItems h0 1 to "Vice President, Sales" Set ComCellValue of hoItems h0 2 to "Tacoma" Set ComSelectItem of hoItems h0 to True Get ComAddItem of hoItems "Janet Leverling" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Kirkland" Get ComAddItem of hoItems "Margaret Peacock" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "Redmond" Get ComAddItem of hoItems "Steven Buchanan" to h0 Set ComCellValue of hoItems h0 1 to "Sales Manager" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Michael Suyama" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Robert King" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Get ComAddItem of hoItems "Laura Callahan" to h0 Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator" Set ComCellValue of hoItems h0 2 to "Seattle" Get ComAddItem of hoItems "Anne Dodsworth" to h0 Set ComCellValue of hoItems h0 1 to "Sales Representative" Set ComCellValue of hoItems h0 2 to "London" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1035 |
How can I unselect all bars
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 1")) "Task" "1/2/2001" "1/4/2001" "K1" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "K2" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 3")) "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "K4" Nothing Set ComItemBar of hoItems 0 "<*>" OLEexBarSelected to True Set ComItemBar of hoItems 0 "<*>" OLEexBarSelected to False Send Destroy to hoItems End_Procedure |
1034 |
Can I select bars using a pattern using wild characters as *,
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 48 Set ComShowNonworkingDates of hoChart to False Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1K" "K1K" Send ComAddBar of hoItems h "Task" "1/5/2001" "1/7/2001" "K2M" "K2M" Send ComAddBar of hoItems h "Task" "1/9/2001" "1/11/2001" "K3K" "K3K" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "Q" "Q" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "M" "M" Set ComItemBar of hoItems 0 "<K*K>" OLEexBarSelected to True Send Destroy to hoItems End_Procedure |
1033 |
How can I select all bars in the item with a specified key
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Set ComPaneWidth of hoChart1 False to 48 Send Destroy to hoChart1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" "K1" Send ComAddBar of hoItems h "Task" "1/5/2001" "1/7/2001" "K2" "K2" Send ComAddBar of hoItems h "Task" "1/9/2001" "1/11/2001" "P" "P" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "Q" "Q" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "M" "M" Set ComItemBar of hoItems h "<K*>" OLEexBarSelected to True Send Destroy to hoItems End_Procedure |
1032 |
How can I select all bars in the specified item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Set ComPaneWidth of hoChart1 False to 48 Send Destroy to hoChart1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" "K1" Send ComAddBar of hoItems h "Task" "1/5/2001" "1/7/2001" "K2" "K2" Send ComAddBar of hoItems h "Task" "1/9/2001" "1/11/2001" "P" "P" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "Q" "Q" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "M" "M" Set ComItemBar of hoItems h "<*>" OLEexBarSelected to True Send Destroy to hoItems End_Procedure |
1031 |
How can I select all bars with a specified key
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Set ComPaneWidth of hoChart1 False to 48 Send Destroy to hoChart1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" "K1" Send ComAddBar of hoItems h "Task" "1/5/2001" "1/7/2001" "K2" "K2" Send ComAddBar of hoItems h "Task" "1/8/2001" "1/10/2001" "P" "P" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "Q" "Q" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "P" "P" Set ComItemBar of hoItems 0 "<P>" OLEexBarSelected to True Send Destroy to hoItems End_Procedure |
1030 |
How can I select all bars
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Set ComPaneWidth of hoChart1 False to 48 Send Destroy to hoChart1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" "K1" Send ComAddBar of hoItems h "Task" "1/5/2001" "1/7/2001" "K2" "K2" Send ComAddBar of hoItems h "Task" "1/8/2001" "1/10/2001" "P" "P" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "Q" "Q" Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "M" "M" Set ComItemBar of hoItems 0 "<*>" OLEexBarSelected to True Send Destroy to hoItems End_Procedure |
1029 |
I have the AllowInsideZoom property on True, but I am still not able to use the inside zoom feature
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 3 Set ComFirstWeekDay of hoChart to OLEexMonday Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "Week: <%ww%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to "<%dddd%>" Set ComAlignment of hoLevel1 to OLECenterAlignment Send Destroy to hoLevel1 Variant voLevel2 Get ComLevel of hoChart 2 to voLevel2 Handle hoLevel2 Get Create (RefClass(cComLevel)) to hoLevel2 Set pvComObject of hoLevel2 to voLevel2 Set ComLabel of hoLevel2 to 65536 Send Destroy to hoLevel2 Set ComNonworkingHours of hoChart to 16773375 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Set ComShowNonworkingHours of hoChart to False Set ComAllowInsideZoom of hoChart to True Variant voInsideZoomFormat Get ComDefaultInsideZoomFormat of hoChart to voInsideZoomFormat Handle hoInsideZoomFormat Get Create (RefClass(cComInsideZoomFormat)) to hoInsideZoomFormat Set pvComObject of hoInsideZoomFormat to voInsideZoomFormat Set ComInsideUnit of hoInsideZoomFormat to OLEexMinute Set ComInsideLabel of hoInsideZoomFormat to "<b><%nn%></b>" Send Destroy to hoInsideZoomFormat Variant voInsideZooms Get ComInsideZooms of hoChart to voInsideZooms Handle hoInsideZooms Get Create (RefClass(cComInsideZooms)) to hoInsideZooms Set pvComObject of hoInsideZooms to voInsideZooms Get ComAdd of hoInsideZooms "1/1/2001 10:00:00 AM" to Nothing Send Destroy to hoInsideZooms Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1028 |
Is there any option to find out if two bars intersects
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Set ComDefaultItemHeight to 22 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "InterectBars" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/1/2001" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComOverlaidType of hoBar to OLEexOverlaidBarsOffset Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "A" "A" Send ComAddBar of hoItems h "Task" "1/3/2001" "1/5/2001" "B" "B" Set ComCellValue of hoItems h 0 to (ComIntersectBars(hoItems,h,"A",h,"B")) Get ComAddItem of hoItems "" to h Send ComAddBar of hoItems h "Task" "1/6/2001" "1/9/2001" "A" "A" Send ComAddBar of hoItems h "Task" "1/10/2001" "1/13/2001" "B" "B" Set ComCellValue of hoItems h 0 to (ComIntersectBars(hoItems,h,"A",h,"B")) Get ComAddItem of hoItems "" to h Send ComAddBar of hoItems h "Task" "1/6/2001" "1/9/2001" "B" "B" Send ComAddBar of hoItems h "Task" "1/10/2001" "1/13/2001" "A" "A" Set ComCellValue of hoItems h 0 to (ComIntersectBars(hoItems,h,"A",h,"B")) Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1027 |
How can I find if a specified hour is a working or non-working hour, when using the ItemNonWorkingUnits
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Hour" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComFormatColumn of hoColumn to "hour(value)" Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Type" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComFormatColumn of hoColumn1 to "value != 0 ? 'non-working' : 'working'" Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 164 Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Set ComUnitScale of hoChart to OLEexHour Set ComNonworkingHours of hoChart to 1 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "1/1/2001" to h Variant v Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Variant vDate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComCellValue of hoItems1 h 0 to vDate Send Destroy to hoItems1 Get ComIsNonworkingDate of hoChart1 vDate Nothing to v Send Destroy to hoChart1 Variant w Move v to w Set ComCellValue of hoItems h 1 to w Get ComAddItem of hoItems "1/1/2001" to h Set ComItemNonworkingUnits of hoItems h false to "hour(value) >0 " Variant v1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Variant vDate1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComCellValue of hoItems2 h 0 to vDate1 Send Destroy to hoItems2 Get ComIsNonworkingDate of hoChart2 vDate1 h to v1 Send Destroy to hoChart2 Move v1 to w Set ComCellValue of hoItems h 1 to w Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1026 |
How can I find if a specified hour is a working or non-working hour
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Hour" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComFormatColumn of hoColumn to "hour(value)" Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Type" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComFormatColumn of hoColumn1 to "value != 0 ? 'non-working' : 'working'" Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 164 Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Set ComUnitScale of hoChart to OLEexHour Set ComNonworkingHours of hoChart to 1 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "1/1/2001" to h Variant v Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Variant vDate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComCellValue of hoItems1 h 0 to vDate Send Destroy to hoItems1 Get ComIsNonworkingDate of hoChart1 vDate Nothing to v Send Destroy to hoChart1 Variant w Move v to w Set ComCellValue of hoItems h 1 to w Get ComAddItem of hoItems "1/1/2001 1:00:00 AM" to h Variant v1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Variant vDate1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComCellValue of hoItems2 h 0 to vDate1 Send Destroy to hoItems2 Get ComIsNonworkingDate of hoChart2 vDate1 Nothing to v1 Send Destroy to hoChart2 Move v1 to w Set ComCellValue of hoItems h 1 to w Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1025 |
How can I find if a specified date-time is a working or non-working unit, when using the ItemNonWorkingUnits
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Date" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 48 Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Type" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComFormatColumn of hoColumn1 to "value != 0 ? 'non-working' : 'working'" Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 128 Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "1/1/2001" to h Variant v Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Variant vDate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComCellValue of hoItems1 h 0 to vDate Send Destroy to hoItems1 Get ComIsNonworkingDate of hoChart1 vDate Nothing to v Send Destroy to hoChart1 Variant w Move v to w Set ComCellValue of hoItems h 1 to w Get ComAddItem of hoItems "1/1/2001" to h Set ComItemNonworkingUnits of hoItems h false to "weekday(value) in (1)" Variant v1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Variant vDate1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComCellValue of hoItems2 h 0 to vDate1 Send Destroy to hoItems2 Get ComIsNonworkingDate of hoChart2 vDate1 h to v1 Send Destroy to hoChart2 Move v1 to w Set ComCellValue of hoItems h 1 to w Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1024 |
How can I find if a specified date-time is a working or non-working unit
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Date" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 48 Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Type" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComFormatColumn of hoColumn1 to "value != 0 ? 'non-working' : 'working'" Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 128 Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "1/1/2001" to h Variant v Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Variant vDate Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComCellValue of hoItems1 h 0 to vDate Send Destroy to hoItems1 Get ComIsNonworkingDate of hoChart1 vDate Nothing to v Send Destroy to hoChart1 Variant w Move v to w Set ComCellValue of hoItems h 1 to w Get ComAddItem of hoItems "1/6/2001" to h Variant v1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Variant vDate1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComCellValue of hoItems2 h 0 to vDate1 Send Destroy to hoItems2 Get ComIsNonworkingDate of hoChart2 vDate1 Nothing to v1 Send Destroy to hoChart2 Move v1 to w Set ComCellValue of hoItems h 1 to w Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1023 |
When zooming to days, the non-working part of the chart occupies some not useful space. Can I reduce it
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/3/2002" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComLevelCount of hoChart to 2 Set ComDrawGridLines of hoChart to OLEexAllLines Set ComFirstWeekDay of hoChart to OLEexMonday Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "Week: <%ww%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to "<%d%>/<%m2%>" Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? 'end' : value" Send Destroy to hoLevel1 Set ComUnitWidth of hoChart to 32 Set ComUnitWidthNonworking of hoChart to -32 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Default" to h Send ComAddBar of hoItems h "Task" "1/4/2002" "1/8/2002" "A" Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1022 |
My chart display only working hours, but when zooming to days, each day shows the non-working part of the day too, even if I use the ShowNonWorkingUnits property on False. What am I doing wrong
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/3/2002 10:00:00 AM" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComLevelCount of hoChart to 2 Set ComDrawGridLines of hoChart to OLEexAllLines Set ComFirstWeekDay of hoChart to OLEexMonday Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ww%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to "<%dd%>" Set ComUnit of hoLevel1 to OLEexHour Set ComCount of hoLevel1 to 24 Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Set ComUnitWidth of hoChart to 32 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Default" to h Send ComAddBar of hoItems h "Task" "1/4/2002 10:00:00 AM" "1/8/2002 2:00:00 AM" "A" Nothing Set ComItemBar of hoItems h "A" OLEexBarKeepWorkingCount to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1021 |
I need to display only working hours and weekend part, but for some items I need another non-working part. Is this possible
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "1/3/2002" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComLevelCount of hoChart to 2 Set ComDrawGridLines of hoChart to OLEexAllLines Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? '' : value" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? 'end' : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Set ComUnitWidthNonworking of hoChart to -24 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Default" to h Send ComAddBar of hoItems h "Task" "1/4/2002" "1/8/2002" "A" Nothing Set ComItemBar of hoItems h "A" OLEexBarKeepWorkingCount to True Get ComAddItem of hoItems "Friday" to h Send ComAddBar of hoItems h "Task" "1/3/2002" "1/7/2002 12:00:00 PM" "A" Nothing Set ComItemBar of hoItems h "A" OLEexBarKeepWorkingCount to True Set ComItemNonworkingUnits of hoItems h false to "weekday(value) in (0,6,5) or hour(value)<10 or hour(value)>=14" Get ComAddItem of hoItems "Till 13" to h Send ComAddBar of hoItems h "Task" "1/4/2002" "1/7/2002 12:00:00 PM" "A" Nothing Set ComItemBar of hoItems h "A" OLEexBarKeepWorkingCount to True Set ComItemNonworkingUnits of hoItems h false to "weekday(value) in (0,6) or hour(value)<10 or hour(value)>=13" Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1020 |
I can display the working hours, but how can I hide the weekend or non-working part of the chart when using the ShowNonWorkingUnits property on False
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Set ComShowNonworkingHours of hoChart to False Send Destroy to hoChart End_Procedure |
1019 |
How can I display only the working hours but uses less space for non-working part, such as weekend
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? '' : value" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? 'end' : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Set ComUnitWidthNonworking of hoChart to -24 Send Destroy to hoChart End_Procedure |
1018 |
How can I display only the working hours but uses less space for non-working part, such as weekend
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? '' : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Set ComUnitWidthNonworking of hoChart to 8 Send Destroy to hoChart End_Procedure |
1017 |
How can I display only the working hours
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Send Destroy to hoChart End_Procedure |
1016 |
How can I specify non-working hours
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Send Destroy to hoChart End_Procedure |
1015 |
How can I display the working hours for a bar
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Tasks" to Nothing Variant voColumn Get ComAdd of hoColumns "Working" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 258 Set ComDef of hoColumn OLEexCellValueToItemBarKey to "A" Set ComFormatColumn of hoColumn to "(0:=round(value*24)) != 0 ? =:0 : ''" Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComAllowCellValueToItemBar of hoItems to True Send Destroy to hoItems Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 96 Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to "<%hh%>" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingHours of hoChart to False Send Destroy to hoChart Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Variant h Get ComAddItem of hoItems1 "Task 1" to h Send ComAddBar of hoItems1 h "Task" "1/4/2002" "1/8/2002" "A" Nothing Set ComItemBar of hoItems1 h "A" OLEexBarKeepWorkingCount to True Get ComAddItem of hoItems1 "Task 2" to h Send ComAddBar of hoItems1 h "Task" "1/3/2002" "1/4/2002" "A" Nothing Set ComItemBar of hoItems1 h "A" OLEexBarKeepWorkingCount to True Send Destroy to hoItems1 Send ComEndUpdate End_Procedure |
1014 |
Is it possible to show only working hours, showing a small part for the weekend days, and in the same time showing the bars by splitting the non-working part and keeping the working units for the bar while moving
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComAdd of hoBars "Task:Split" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComShortcut of hoBar to "Task" Send Destroy to hoBar Send Destroy to hoBars Set ComFirstVisibleDate of hoChart to "1/3/2002" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%ddd%>" Set ComAlignment of hoLevel to OLECenterAlignment Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? `` : value" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComDrawGridLines of hoLevel1 to True Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? `<font ;6>weekend</font>` : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to True Set ComShowNonworkingHours of hoChart to False Set ComUnitWidthNonworking of hoChart to -40 Send Destroy to hoChart Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/4/2002" "1/8/2002" "A" Nothing Set ComItemBar of hoItems h "A" OLEexBarKeepWorkingCount to True Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1013 |
How can I show bars with different solid color but black border
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voAppearance Get ComVisualAppearance to voAppearance Handle hoAppearance Get Create (RefClass(cComAppearance)) to hoAppearance Set pvComObject of hoAppearance to voAppearance Get ComAdd of hoAppearance 1 "C:\Program Files\Exontrol\ExG2antt.NET\sample\EBN\blackbox.ebn" to Nothing Send Destroy to hoAppearance Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "1/1/2001" Send Destroy to hoChart Variant voChart1 Get ComChart to voChart1 Handle hoChart1 Get Create (RefClass(cComChart)) to hoChart1 Set pvComObject of hoChart1 to voChart1 Variant voBars Get ComBars of hoChart1 to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Variant voBar1 Get ComItem of hoBar "Task" to voBar1 Handle hoBar1 Get Create (RefClass(cComBar)) to hoBar1 Set pvComObject of hoBar1 to voBar1 Set ComColor of hoBar1 to |CI$1000000 Set ComHeight of hoBar1 to 15 Send Destroy to hoBar1 Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart1 Variant voChart2 Get ComChart to voChart2 Handle hoChart2 Get Create (RefClass(cComChart)) to hoChart2 Set pvComObject of hoChart2 to voChart2 Set ComPaneWidth of hoChart2 False to 0 Send Destroy to hoChart2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "" Nothing Set ComItemBar of hoItems h "" OLEexBarColor to 65535 Get ComAddItem of hoItems "Task" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "" Nothing Set ComItemBar of hoItems h "" OLEexBarColor to 255 Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1012 |
I want to display a vertical line for each week, while I still need a vertical separator for each day. Is this possible
Procedure OnCreate Forward Send OnCreate Set ComGridLineColor to (RGB(240,240,240)) Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComDrawGridLines of hoChart to OLEexAllLines Set ComNonworkingDays of hoChart to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Set ComGridLineColor of hoLevel to (RGB(0,0,0)) Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComDrawGridLines of hoLevel1 to True Set ComGridLineColor of hoLevel1 to (RGB(240,240,240)) Send Destroy to hoLevel1 Send Destroy to hoChart End_Procedure |
1011 |
How can I display the levels as year, day, AM and PM for each day
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "12/1/2009" Set ComUnitWidth of hoChart to 22 Set ComLevelCount of hoChart to 3 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%yyyy%>" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to "<%mm%>/<%dd%>" Send Destroy to hoLevel1 Variant voLevel2 Get ComLevel of hoChart 2 to voLevel2 Handle hoLevel2 Get Create (RefClass(cComLevel)) to hoLevel2 Set pvComObject of hoLevel2 to voLevel2 Set ComLabel of hoLevel2 to "<%AM/PM%>" Set ComCount of hoLevel2 to 12 Send Destroy to hoLevel2 Send Destroy to hoChart End_Procedure |
1010 |
How can I change the pattern for a specified time unit, in the chart area
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Set ComFirstVisibleDate of hoChart to "1/1/2008" Set ComAllowInsideZoom of hoChart to True Set ComAllowResizeInsideZoom of hoChart to False Set ComInsideZoomOnDblClick of hoChart to False Variant voInsideZoomFormat Get ComDefaultInsideZoomFormat of hoChart to voInsideZoomFormat Handle hoInsideZoomFormat Get Create (RefClass(cComInsideZoomFormat)) to hoInsideZoomFormat Set pvComObject of hoInsideZoomFormat to voInsideZoomFormat Set ComPatternChart of hoInsideZoomFormat to OLEexPatternBDiagonal Set ComPatternColorChart of hoInsideZoomFormat to (RGB(255,0,0)) Send Destroy to hoInsideZoomFormat Variant voInsideZooms Get ComInsideZooms of hoChart to voInsideZooms Handle hoInsideZooms Get Create (RefClass(cComInsideZooms)) to hoInsideZooms Set pvComObject of hoInsideZooms to voInsideZooms Set ComSplitBaseLevel of hoInsideZooms to False Set ComDefaultWidth of hoInsideZooms to 18 Variant voInsideZoom Get ComAdd of hoInsideZooms "1/4/2008" to voInsideZoom Handle hoInsideZoom Get Create (RefClass(cComInsideZoom)) to hoInsideZoom Set pvComObject of hoInsideZoom to voInsideZoom Set ComAllowInsideFormat of hoInsideZoom to False Send Destroy to hoInsideZoom Send Destroy to hoInsideZooms Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1009 |
How can I hide the non-working hours, but still display the non-working days with even less space
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "11/19/2009" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%dddd%>" Set ComAlignment of hoLevel to OLECenterAlignment Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? `` : value" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComDrawGridLines of hoLevel1 to True Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? `<font ;6>weekend</font>` : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to True Set ComShowNonworkingHours of hoChart to False Set ComUnitWidth of hoChart to 32 Set ComUnitWidthNonworking of hoChart to -32 Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1008 |
How can I hide the non-working hours, but still display the non-working days with less space
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "11/19/2009" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%dddd%>" Set ComAlignment of hoLevel to OLECenterAlignment Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? `<font ;6>` + value + `</font>` : value" Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComDrawGridLines of hoLevel1 to True Set ComFormatLabel of hoLevel1 to "weekday(dvalue) in (0,6) ? `<font ;6>` + value + `</font>` : value" Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to True Set ComShowNonworkingHours of hoChart to False Set ComUnitWidth of hoChart to 32 Set ComUnitWidthNonworking of hoChart to 12 Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1007 |
How can I hide the non-working hours, but still display the non-working days
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "11/19/2009" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%dddd%>" Set ComAlignment of hoLevel to OLECenterAlignment Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComDrawGridLines of hoLevel1 to True Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to True Set ComShowNonworkingHours of hoChart to False Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1006 |
How can I hide the non-working hours, and the non-working days
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstVisibleDate of hoChart to "11/19/2009" Set ComDrawGridLines of hoChart to OLEexAllLines Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Set ComPaneWidth of hoChart False to 0 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%dddd%>" Set ComAlignment of hoLevel to OLECenterAlignment Send Destroy to hoLevel Variant voLevel1 Get ComLevel of hoChart 1 to voLevel1 Handle hoLevel1 Get Create (RefClass(cComLevel)) to hoLevel1 Set pvComObject of hoLevel1 to voLevel1 Set ComLabel of hoLevel1 to 65536 Set ComDrawGridLines of hoLevel1 to True Send Destroy to hoLevel1 Set ComNonworkingHours of hoChart to 16761855 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Set ComShowNonworkingHours of hoChart to False Send Destroy to hoChart Send ComEndUpdate End_Procedure |
1005 |
Can I highlights the non-working hours while my chart shows days
Procedure OnCreate Forward Send OnCreate Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 0 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComUnitWidth of hoChart to 48 Set ComLevelCount of hoChart to 2 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComLabel of hoLevel to "<%d%>" Set ComUnit of hoLevel to OLEexHour Set ComCount of hoLevel to 24 Send Destroy to hoLevel Set ComNonworkingHours of hoChart to 127 Send Destroy to hoChart End_Procedure |
1004 |
How can I reduce the space/area being occupied by non-working units days or hours (method 2)
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 64 Set ComUnitWidthNonworking of hoChart to -8 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? '.' : value" Send Destroy to hoLevel Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" Nothing Send ComAddBar of hoItems h "Task" "1/5/2001" "1/6/2001" "K2" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "K4" Nothing Set ComItemBar of hoItems h "<*>" OLEexBarColor to 255 Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1003 |
How can I reduce the space/area being occupied by non-working units days or hours (method 1)
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 64 Set ComUnitWidthNonworking of hoChart to 4 Variant voLevel Get ComLevel of hoChart 1 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComFormatLabel of hoLevel to "weekday(dvalue) in (0,6) ? '' : value" Send Destroy to hoLevel Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" Nothing Send ComAddBar of hoItems h "Task" "1/5/2001" "1/6/2001" "K2" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "K4" Nothing Set ComItemBar of hoItems h "<*>" OLEexBarColor to 255 Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1002 |
How can I hide the non-working units
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComFirstWeekDay of hoChart to OLEexMonday Set ComLevelCount of hoChart to 2 Set ComFirstVisibleDate of hoChart to "1/1/2001" Set ComPaneWidth of hoChart False to 64 Set ComShowNonworkingUnits of hoChart to False Set ComShowNonworkingDates of hoChart to False Set ComDrawGridLines of hoChart to OLEexVLines Variant voLevel Get ComLevel of hoChart 0 to voLevel Handle hoLevel Get Create (RefClass(cComLevel)) to hoLevel Set pvComObject of hoLevel to voLevel Set ComDrawGridLines of hoLevel to True Send Destroy to hoLevel Set ComGridLineStyle of hoChart to OLEexGridLinesGeometric Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Task 1" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/4/2001" "K1" Nothing Send ComAddBar of hoItems h "Task" "1/5/2001" "1/6/2001" "K2" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/2/2001" "1/4/2001" "K3" Nothing Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 4")) "Task" "1/2/2001" "1/4/2001" "K4" Nothing Set ComItemBar of hoItems h "<*>" OLEexBarColor to 255 Send Destroy to hoItems Send ComEndUpdate End_Procedure |
1001 |
How can I determine that a certain bar is the topmost (zorder)
Procedure OnCreate Forward Send OnCreate Send ComBeginUpdate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Task" to Nothing Send Destroy to hoColumns Variant voChart Get ComChart to voChart Handle hoChart Get Create (RefClass(cComChart)) to hoChart Set pvComObject of hoChart to voChart Set ComPaneWidth of hoChart False to 48 Set ComFirstVisibleDate of hoChart to "12/27/2000" Variant voBars Get ComBars of hoChart to voBars Handle hoBars Get Create (RefClass(cComBars)) to hoBars Set pvComObject of hoBars to voBars Variant voBar Get ComItem of hoBars "Task" to voBar Handle hoBar Get Create (RefClass(cComBar)) to hoBar Set pvComObject of hoBar to voBar Set ComPattern of hoBar to OLEexPatternSolid Send Destroy to hoBar Send Destroy to hoBars Send Destroy to hoChart Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "B in front" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "A" Nothing Send ComAddBar of hoItems h "Task" "1/3/2001" "1/5/2001" "B" "<fgcolor=FF0000>B</fgcolor>" Set ComItemBar of hoItems h "B" OLEexBarOffset to -2 Set ComItemBar of hoItems h "B" OLEexBarHAlignCaption to 18 Set ComItemBar of hoItems h "B" OLEexBarColor to 255 Get ComAddItem of hoItems "A in back" to h Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "A" "<fgcolor=FF0000>A</fgcolor>" Set ComItemBar of hoItems h "A" OLEexBarOffset to -2 Set ComItemBar of hoItems h "A" OLEexBarHAlignCaption to 18 Set ComItemBar of hoItems h "A" OLEexBarColor to 255 Send ComAddBar of hoItems h "Task" "1/3/2001" "1/5/2001" "B" Nothing Send Destroy to hoItems Send ComEndUpdate End_Procedure |